Bring texture and depth into your home with our stunning collection of Ombre Custom Rugs from Rugartisan. Each rug is hand-crafted, making it completely unique to your space. Our skilled artisans use a special dyeing technique to create a beautiful ombre effect, adding a touch of luxury to any room. Choose from our wide range of colors and sizes to find the perfect custom rug for your home. Elevate your decor with an Ombre Custom Rug from Rugartisan.
select `id`, `code`, `value_per_channel`, `value_per_locale`, `type`, `is_filterable` from `attributes` where `code` in ('weavingtype', 'material', 'shape')rugartisan_com_sa330ms
select `id`, `code`, `value_per_channel`, `value_per_locale`, `type`, `is_filterable` from `attributes` where `code` in ('weavingtype', 'material', 'shape')rugartisan_com_sa260ms
select `id`, `code`, `value_per_channel`, `value_per_locale`, `type`, `is_filterable` from `attributes` where `code` in ('weavingtype', 'material', 'shape')rugartisan_com_sa440ms
select `id`, `code`, `value_per_channel`, `value_per_locale`, `type`, `is_filterable` from `attributes` where `code` in ('weavingtype', 'material', 'shape')rugartisan_com_sa310ms
select `id`, `code`, `value_per_channel`, `value_per_locale`, `type`, `is_filterable` from `attributes` where `code` in ('weavingtype', 'material', 'shape')rugartisan_com_sa290ms
select `id`, `code`, `value_per_channel`, `value_per_locale`, `type`, `is_filterable` from `attributes` where `code` in ('weavingtype', 'material', 'shape')rugartisan_com_sa350ms
select `attributes`.*, `category_filterable_attributes`.`category_id` as `pivot_category_id`, `category_filterable_attributes`.`attribute_id` as `pivot_attribute_id` from `attributes` innerjoin `category_filterable_attributes` on `attributes`.`id` = `category_filterable_attributes`.`attribute_id` where `category_filterable_attributes`.`category_id` =111rugartisan_com_sa710ms
select*from `attribute_options` where `attribute_options`.`attribute_id` in (11, 27, 28, 29, 38) orderby `sort_order` ascrugartisan_com_sa490ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =14and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa440ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =15and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa260ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =16and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa230ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =17and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa230ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =18and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa180ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =19and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa180ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =20and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa180ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =21and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa200ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =22and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa190ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =23and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa180ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =24and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa180ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =25and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa210ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =26and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa200ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =27and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa180ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =28and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa170ms
select*from `attribute_translations` where `attribute_translations`.`attribute_id` =27and `attribute_translations`.`attribute_id` isnotnullrugartisan_com_sa500ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =10and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa220ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =1345and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa340ms
select*from `attribute_translations` where `attribute_translations`.`attribute_id` =38and `attribute_translations`.`attribute_id` isnotnullrugartisan_com_sa360ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =79and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa200ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =80and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa190ms
select*from `attribute_option_translations` where `attribute_option_translations`.`attribute_option_id` =83and `attribute_option_translations`.`attribute_option_id` isnotnullrugartisan_com_sa350ms
select*from `locales` where `locales`.`id` =1 limit 1rugartisan_com_sa360ms
select*from `currencies` where `currencies`.`id` =4 limit 1rugartisan_com_sa290ms
select*from `core_config` where `code` ='catalog.dynamicmeta.categories.meta_title'and `channel_code` ='default'and `locale_code` ='en'rugartisan_com_sa500ms
select*from `core_config` where `code` ='catalog.dynamicmeta.categories.meta_description'and `channel_code` ='default'and `locale_code` ='en'rugartisan_com_sa390ms
select*from `core_config` where `code` ='catalog.dynamicmeta.categories.meta_keywords'and `channel_code` ='default'and `locale_code` ='en'rugartisan_com_sa380ms
select*from `core_config` where `code` ='catalog.products.storefront.products_per_page'and `channel_code` ='default'rugartisan_com_sa370ms
select*from `core_config` where `code` ='catalog.products.storefront.sort_by'and `channel_code` ='default'rugartisan_com_sa360ms
select*from `currencies` where `code` ='SAR'rugartisan_com_sa260ms
select*from `core_config` where `code` ='company.settings.general.phone'and `channel_code` ='default'and `locale_code` ='en'rugartisan_com_sa570ms
Webkul\Product501
Details
Models
0. Webkul\Product\Models\ProductFlat (70)
Queries
selectdistinct `pc`.`category_id` as `id`, `ct`.`name`, `ct`.`url_path`, `ct`.`slug`, count(distinct(pc.product_id)) as total from `product_flat` innerjoin `product_categories` as `pc` on `product_flat`.`product_id` = `pc`.`product_id` innerjoin `categories` as `c` on `c`.`id` = `pc`.`category_id` innerjoin `category_translations` as `ct` on `ct`.`category_id` = `c`.`id` where `product_flat`.`channel` ='default'and `product_flat`.`locale` ='en'and `product_flat`.`url_key` isnotnulland `product_flat`.`status` =1and `product_flat`.`visible_individually` =1and `product_flat`.`material_label` in ('Pure Wool') and `product_flat`.`shape_label` in ('Round') and `product_flat`.`weavingtype_label` in ('Hand Tufted') and `ct`.`locale` ='en'and `c`.`parent_id` =2and `c`.`status` =1and `product_flat`.`channel` ='default'and `product_flat`.`locale` ='en'and `product_flat`.`url_key` isnotnulland `product_flat`.`status` =1and `product_flat`.`visible_individually` =1and `product_flat`.`material_label` in ('Pure Wool') and `product_flat`.`shape_label` in ('Round') and `product_flat`.`weavingtype_label` in ('Hand Tufted') groupby `pc`.`category_id` orderby `product_flat`.`material` asc, `product_flat`.`weavingtype` asc, `pc`.`position` asc, `product_flat`.`material` asc, `product_flat`.`weavingtype` asc, `pc`.`position` asc, `ct`.`url_path` ascrugartisan_com_sa143.48s
selectdistinct `product_flat`.*from `product_flat` leftjoin `product_categories` as `pc` on `pc`.`product_id` = `product_flat`.`product_id` where `product_flat`.`channel` ='default'and `product_flat`.`locale` ='en'and `product_flat`.`url_key` isnotnulland `product_flat`.`status` =1and `product_flat`.`visible_individually` =1and `product_flat`.`material_label` in ('Pure Wool') and `product_flat`.`shape_label` in ('Round') and `product_flat`.`weavingtype_label` in ('Hand Tufted') and `product_flat`.`channel` ='default'and `product_flat`.`locale` ='en'and `product_flat`.`url_key` isnotnulland `product_flat`.`status` =1and `product_flat`.`visible_individually` =1and `product_flat`.`material_label` in ('Pure Wool') and `product_flat`.`shape_label` in ('Round') and `product_flat`.`weavingtype_label` in ('Hand Tufted') and `product_flat`.`channel` ='default'and `product_flat`.`locale` ='en'and `product_flat`.`url_key` isnotnulland `product_flat`.`status` =1and `product_flat`.`visible_individually` =1and `product_flat`.`material_label` in ('Pure Wool') and `product_flat`.`shape_label` in ('Round') and `product_flat`.`weavingtype_label` in ('Hand Tufted') and `pc`.`category_id` =111and `product_flat`.`channel` ='default'and `product_flat`.`locale` ='en'and `product_flat`.`url_key` isnotnulland `product_flat`.`status` =1and `product_flat`.`visible_individually` =1and `product_flat`.`material_label` in ('Pure Wool') and `product_flat`.`shape_label` in ('Round') and `product_flat`.`weavingtype_label` in ('Hand Tufted') orderby `product_flat`.`material` asc, `product_flat`.`weavingtype` asc, `pc`.`position` asc, `product_flat`.`material` asc, `product_flat`.`weavingtype` asc, `pc`.`position` asc, `product_flat`.`material` asc, `product_flat`.`weavingtype` asc, `pc`.`position` asc, `product_flat`.`material` asc, `product_flat`.`weavingtype` asc, `pc`.`position` asc limit 40offset0rugartisan_com_sa10.57s
selectmax(`price`) as aggregate from `product_flat` leftjoin `product_categories` on `product_flat`.`product_id` = `product_categories`.`product_id` where `product_categories`.`category_id` =111and `product_flat`.`visible_individually` ='1'rugartisan_com_sa8.74s
selectmin(`price`) as aggregate from `product_flat` leftjoin `product_categories` on `product_flat`.`product_id` = `product_categories`.`product_id` where `product_categories`.`category_id` =111and `product_flat`.`visible_individually` ='1'and `product_flat`.`price` >0rugartisan_com_sa7.48s
select `pa`.`attribute_id`, `pa`.`text_value`, count(distinct(pa.product_id)) as total from `product_flat` innerjoin `product_categories` on `product_flat`.`product_id` = `product_categories`.`product_id` leftjoin `product_attribute_values` as `pa` on `product_flat`.`product_id` = `pa`.`product_id` where `product_flat`.`channel` ='default'and `product_flat`.`locale` ='en'and `product_categories`.`category_id` =111and `pa`.`attribute_id` in (11, 27, 28, 38) groupby `pa`.`attribute_id`, `pa`.`text_value`rugartisan_com_sa70.46s
select*from `category_translations` where `category_translations`.`category_id` in (111)300μs/packages/Webkul/Category/src/Repositories/CategoryRepository.php:187rugartisan_com_sa
select*from `category_translations` where `category_translations`.`category_id` in (111)270μs/packages/Webkul/Core/src/Eloquent/Repository.php:57rugartisan_com_sa
select `id`, `code`, `value_per_channel`, `value_per_locale`, `type`, `is_filterable` from `attributes` where `code` in ('weavingtype', 'material', 'shape')330μs/vendor/prettus/l5-repository/src/Prettus/Repository/Eloquent/BaseRepository.php:578rugartisan_com_sa
select `id`, `code`, `value_per_channel`, `value_per_locale`, `type`, `is_filterable` from `attributes` where `code` in ('weavingtype', 'material', 'shape')260μs/vendor/prettus/l5-repository/src/Prettus/Repository/Eloquent/BaseRepository.php:578rugartisan_com_sa
selectdistinct `pc`.`category_id` as `id`, `ct`.`name`, `ct`.`url_path`, `ct`.`slug`, count(distinct(pc.product_id)) as total from `product_flat` innerjoin `product_categories` as `pc` on `product_flat`.`product_id` = `pc`.`product_id` innerjoin `categories` as `c` on `c`.`id` = `pc`.`category_id` innerjoin `category_translations` as `ct` on `ct`.`category_id` = `c`.`id` where `product_flat`.`channel` ='default'and `product_flat`.`locale` ='en'and `product_flat`.`url_key` isnotnulland `product_flat`.`status` =1and `product_flat`.`visible_individually` =1and `product_flat`.`material_label` in ('Pure Wool') and `product_flat`.`shape_label` in ('Round') and `product_flat`.`weavingtype_label` in ('Hand Tufted') and `ct`.`locale` ='en'and `c`.`parent_id` =2and `c`.`status` =1and `product_flat`.`channel` ='default'and `product_flat`.`locale` ='en'and `product_flat`.`url_key` isnotnulland `product_flat`.`status` =1and `product_flat`.`visible_individually` =1and `product_flat`.`material_label` in ('Pure Wool') and `product_flat`.`shape_label` in ('Round') and `product_flat`.`weavingtype_label` in ('Hand Tufted') groupby `pc`.`category_id` orderby `product_flat`.`material` asc, `product_flat`.`weavingtype` asc, `pc`.`position` asc, `product_flat`.`material` asc, `product_flat`.`weavingtype` asc, `pc`.`position` asc, `ct`.`url_path` asc143ms/packages/Webkul/Product/src/Repositories/ProductRepository.php:577rugartisan_com_sa
select `id`, `code`, `value_per_channel`, `value_per_locale`, `type`, `is_filterable` from `attributes` where `code` in ('weavingtype', 'material', 'shape')440μs/vendor/prettus/l5-repository/src/Prettus/Repository/Eloquent/BaseRepository.php:578rugartisan_com_sa
select `id`, `code`, `value_per_channel`, `value_per_locale`, `type`, `is_filterable` from `attributes` where `code` in ('weavingtype', 'material', 'shape')310μs/vendor/prettus/l5-repository/src/Prettus/Repository/Eloquent/BaseRepository.php:578rugartisan_com_sa
select `id`, `code`, `value_per_channel`, `value_per_locale`, `type`, `is_filterable` from `attributes` where `code` in ('weavingtype', 'material', 'shape')290μs/vendor/prettus/l5-repository/src/Prettus/Repository/Eloquent/BaseRepository.php:578rugartisan_com_sa
select `id`, `code`, `value_per_channel`, `value_per_locale`, `type`, `is_filterable` from `attributes` where `code` in ('weavingtype', 'material', 'shape')350μs/vendor/prettus/l5-repository/src/Prettus/Repository/Eloquent/BaseRepository.php:578rugartisan_com_sa
selectcount(*) as aggregate from (selectdistinct `product_flat`.*from `product_flat` leftjoin `product_categories` as `pc` on `pc`.`product_id` = `product_flat`.`product_id` where `product_flat`.`channel` ='default'and `product_flat`.`locale` ='en'and `product_flat`.`url_key` isnotnulland `product_flat`.`status` =1and `product_flat`.`visible_individually` =1and `product_flat`.`material_label` in ('Pure Wool') and `product_flat`.`shape_label` in ('Round') and `product_flat`.`weavingtype_label` in ('Hand Tufted') and `product_flat`.`channel` ='default'and `product_flat`.`locale` ='en'and `product_flat`.`url_key` isnotnulland `product_flat`.`status` =1and `product_flat`.`visible_individually` =1and `product_flat`.`material_label` in ('Pure Wool') and `product_flat`.`shape_label` in ('Round') and `product_flat`.`weavingtype_label` in ('Hand Tufted') and `product_flat`.`channel` ='default'and `product_flat`.`locale` ='en'and `product_flat`.`url_key` isnotnulland `product_flat`.`status` =1and `product_flat`.`visible_individually` =1and `product_flat`.`material_label` in ('Pure Wool') and `product_flat`.`shape_label` in ('Round') and `product_flat`.`weavingtype_label` in ('Hand Tufted') and `pc`.`category_id` =111and `product_flat`.`channel` ='default'and `product_flat`.`locale` ='en'and `product_flat`.`url_key` isnotnulland `product_flat`.`status` =1and `product_flat`.`visible_individually` =1and `product_flat`.`material_label` in ('Pure Wool') and `product_flat`.`shape_label` in ('Round') and `product_flat`.`weavingtype_label` in ('Hand Tufted') orderby `product_flat`.`material` asc, `product_flat`.`weavingtype` asc, `pc`.`position` asc, `product_flat`.`material` asc, `product_flat`.`weavingtype` asc, `pc`.`position` asc, `product_flat`.`material` asc, `product_flat`.`weavingtype` asc, `pc`.`position` asc, `product_flat`.`material` asc, `product_flat`.`weavingtype` asc, `pc`.`position` asc) c24.49ms/packages/Webkul/Product/src/Repositories/ProductRepository.php:595rugartisan_com_sa
select*from `category_translations` where `category_translations`.`category_id` in (2)510μs/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161rugartisan_com_sa
select `attributes`.*, `category_filterable_attributes`.`category_id` as `pivot_category_id`, `category_filterable_attributes`.`attribute_id` as `pivot_attribute_id` from `attributes` innerjoin `category_filterable_attributes` on `attributes`.`id` = `category_filterable_attributes`.`attribute_id` where `category_filterable_attributes`.`category_id` =111710μs/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161rugartisan_com_sa
selectmax(`price`) as aggregate from `product_flat` leftjoin `product_categories` on `product_flat`.`product_id` = `product_categories`.`product_id` where `product_categories`.`category_id` =111and `product_flat`.`visible_individually` ='1'8.74ms/packages/Webkul/Product/src/Repositories/ProductFlatRepository.php:39rugartisan_com_sa
selectmin(`price`) as aggregate from `product_flat` leftjoin `product_categories` on `product_flat`.`product_id` = `product_categories`.`product_id` where `product_categories`.`category_id` =111and `product_flat`.`visible_individually` ='1'and `product_flat`.`price` >07.48ms/packages/Webkul/Product/src/Repositories/ProductFlatRepository.php:397rugartisan_com_sa
select `pa`.`attribute_id`, `pa`.`text_value`, count(distinct(pa.product_id)) as total from `product_flat` innerjoin `product_categories` on `product_flat`.`product_id` = `product_categories`.`product_id` leftjoin `product_attribute_values` as `pa` on `product_flat`.`product_id` = `pa`.`product_id` where `product_flat`.`channel` ='default'and `product_flat`.`locale` ='en'and `product_categories`.`category_id` =111and `pa`.`attribute_id` in (11, 27, 28, 38) groupby `pa`.`attribute_id`, `pa`.`text_value`70.46ms/packages/Webkul/Product/src/Repositories/ProductFlatRepository.php:208rugartisan_com_sa